Overview

Dataset statistics

Number of variables73
Number of observations571989
Missing cells12954380
Missing cells (%)31.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory314.2 MiB
Average record size in memory576.0 B

Variable types

CAT60
UNSUPPORTED6
BOOL4
DATE3

Reproduction

Analysis started2021-04-07 09:21:56.322903
Analysis finished2021-04-07 09:30:32.809487
Duration8 minutes and 36.49 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

inactive_flag has constant value "0" Constant
deleted_flag has constant value "0" Constant
modify_id has a high cardinality: 761 distinct values High cardinality
hco_business_id has a high cardinality: 555511 distinct values High cardinality
hco_name has a high cardinality: 443574 distinct values High cardinality
phone_number has a high cardinality: 478218 distinct values High cardinality
formatted_name has a high cardinality: 443574 distinct values High cardinality
beds has a high cardinality: 707 distinct values High cardinality
jp_hco_id has a high cardinality: 555511 distinct values High cardinality
jp_account_furigana has a high cardinality: 412648 distinct values High cardinality
jp_hco_name has a high cardinality: 484174 distinct values High cardinality
jp_hco_name_kana has a high cardinality: 461518 distinct values High cardinality
jp_hco_shortname has a high cardinality: 439543 distinct values High cardinality
jp_hco_shortname_kana has a high cardinality: 412587 distinct values High cardinality
jp_management_small_class has a high cardinality: 63 distinct values High cardinality
jp_hco_class has a high cardinality: 89 distinct values High cardinality
jp_related_univ_parent has a high cardinality: 195 distinct values High cardinality
jp_open_close_business_date has a high cardinality: 175 distinct values High cardinality
jp_hco_rep_code has a high cardinality: 188418 distinct values High cardinality
jp_hco_rep_kana has a high cardinality: 211186 distinct values High cardinality
jp_hco_rep_kanji has a high cardinality: 247490 distinct values High cardinality
hco_dcf_cd has a high cardinality: 554052 distinct values High cardinality
jp_duplicate_hco_code has a high cardinality: 13366 distinct values High cardinality
jp_permitted_beds has a high cardinality: 728 distinct values High cardinality
hco_external_id has a high cardinality: 563543 distinct values High cardinality
parent_hco_key has a high cardinality: 571988 distinct values High cardinality
parent_hco_name has a high cardinality: 443573 distinct values High cardinality
address_line_1 has a high cardinality: 60991 distinct values High cardinality
city has a high cardinality: 1345 distinct values High cardinality
postcode has a high cardinality: 62225 distinct values High cardinality
map has a high cardinality: 62234 distinct values High cardinality
hco_address_source_id has a high cardinality: 563531 distinct values High cardinality
address_external_id has a high cardinality: 563531 distinct values High cardinality
address_phone has a high cardinality: 478111 distinct values High cardinality
jp_local_area_code has a high cardinality: 355 distinct values High cardinality
jp_city_code has a high cardinality: 1368 distinct values High cardinality
jp_larger_section_code has a high cardinality: 851 distinct values High cardinality
jp_smaller_section_code has a high cardinality: 320 distinct values High cardinality
jp_address_furigana has a high cardinality: 60751 distinct values High cardinality
hco_type is highly correlated with country_code and 9 other fieldsHigh correlation
country_code is highly correlated with hco_type and 13 other fieldsHigh correlation
jp_hco_category is highly correlated with country_code and 9 other fieldsHigh correlation
jp_hospital_type is highly correlated with country_code and 5 other fieldsHigh correlation
jp_management_large_class is highly correlated with country_code and 3 other fieldsHigh correlation
jp_management_small_class is highly correlated with country_code and 5 other fieldsHigh correlation
jp_hco_hpgp_class is highly correlated with country_code and 5 other fieldsHigh correlation
jp_hco_class is highly correlated with country_code and 3 other fieldsHigh correlation
jp_hco_kind_code is highly correlated with country_code and 6 other fieldsHigh correlation
jp_hco_kind is highly correlated with country_code and 6 other fieldsHigh correlation
jp_psychiatric_ward_nursing_type is highly correlated with jp_management_small_classHigh correlation
jp_hco_pharmacy_class is highly correlated with country_code and 3 other fieldsHigh correlation
jp_psychosis_hospital_bed_number is highly correlated with jp_management_small_classHigh correlation
record_type_name is highly correlated with country_code and 1 other fieldsHigh correlation
state is highly correlated with country_code and 2 other fieldsHigh correlation
jp_prefecture_code is highly correlated with country_code and 2 other fieldsHigh correlation
jp_redai_prefecture_code is highly correlated with country_code and 5 other fieldsHigh correlation
hco_business_id has 16401 (2.9%) missing values Missing
inactive_reason has 571989 (100.0%) missing values Missing
hco_type has 16401 (2.9%) missing values Missing
hco_type_english_name has 571989 (100.0%) missing values Missing
sector has 571989 (100.0%) missing values Missing
phone_number has 12683 (2.2%) missing values Missing
fax_number has 571989 (100.0%) missing values Missing
website has 571989 (100.0%) missing values Missing
territory_name has 571988 (> 99.9%) missing values Missing
remarks has 571989 (100.0%) missing values Missing
beds has 309343 (54.1%) missing values Missing
jp_hco_category has 16401 (2.9%) missing values Missing
jp_hco_id has 16401 (2.9%) missing values Missing
jp_hospital_type has 17938 (3.1%) missing values Missing
jp_account_furigana has 8498 (1.5%) missing values Missing
jp_hco_name_kana has 8572 (1.5%) missing values Missing
jp_hco_shortname has 8582 (1.5%) missing values Missing
jp_hco_shortname_kana has 8620 (1.5%) missing values Missing
jp_management_large_class has 102766 (18.0%) missing values Missing
jp_management_small_class has 102766 (18.0%) missing values Missing
jp_hco_hpgp_class has 17938 (3.1%) missing values Missing
jp_hco_class has 25936 (4.5%) missing values Missing
jp_hco_kind_code has 325493 (56.9%) missing values Missing
jp_hco_kind has 325493 (56.9%) missing values Missing
jp_psychiatric_ward_nursing_type has 571986 (> 99.9%) missing values Missing
jp_related_univ_parent has 570747 (99.8%) missing values Missing
jp_open_close_business_date has 570253 (99.7%) missing values Missing
jp_hco_rep_code has 371832 (65.0%) missing values Missing
jp_hco_rep_kana has 195961 (34.3%) missing values Missing
jp_hco_rep_kanji has 195952 (34.3%) missing values Missing
jp_hco_pharmacy_class has 25122 (4.4%) missing values Missing
hco_dcf_cd has 17937 (3.1%) missing values Missing
jp_duplicate_hco_code has 558552 (97.7%) missing values Missing
jp_permitted_beds has 394927 (69.0%) missing values Missing
jp_psychiatric_ward_number has 571988 (> 99.9%) missing values Missing
jp_psychosis_hospital_bed_number has 571986 (> 99.9%) missing values Missing
address_line_1 has 8457 (1.5%) missing values Missing
address_line_2 has 571988 (> 99.9%) missing values Missing
suburb_town has 571988 (> 99.9%) missing values Missing
city has 8853 (1.5%) missing values Missing
state has 8896 (1.6%) missing values Missing
postcode has 9617 (1.7%) missing values Missing
brick has 571988 (> 99.9%) missing values Missing
map has 8457 (1.5%) missing values Missing
appt_required_flag has 8457 (1.5%) missing values Missing
address_phone has 12825 (2.2%) missing values Missing
address_fax has 571988 (> 99.9%) missing values Missing
primary_flag has 8457 (1.5%) missing values Missing
jp_prefecture_code has 8895 (1.6%) missing values Missing
jp_local_area_code has 8949 (1.6%) missing values Missing
jp_city_code has 8853 (1.5%) missing values Missing
jp_redai_prefecture_code has 571863 (> 99.9%) missing values Missing
jp_larger_section_code has 9214 (1.6%) missing values Missing
jp_smaller_section_code has 9261 (1.6%) missing values Missing
jp_address_furigana has 9727 (1.7%) missing values Missing
hco_business_id is uniformly distributed Uniform
phone_number is uniformly distributed Uniform
jp_hco_id is uniformly distributed Uniform
jp_hco_rep_code is uniformly distributed Uniform
hco_dcf_cd is uniformly distributed Uniform
jp_duplicate_hco_code is uniformly distributed Uniform
parent_hco_key is uniformly distributed Uniform
address_phone is uniformly distributed Uniform
hco_key has unique values Unique
hco_source_id has unique values Unique
inactive_reason is an unsupported type, check if it needs cleaning or further analysis Unsupported
hco_type_english_name is an unsupported type, check if it needs cleaning or further analysis Unsupported
sector is an unsupported type, check if it needs cleaning or further analysis Unsupported
fax_number is an unsupported type, check if it needs cleaning or further analysis Unsupported
website is an unsupported type, check if it needs cleaning or further analysis Unsupported
remarks is an unsupported type, check if it needs cleaning or further analysis Unsupported

Variables

hco_key
Categorical

UNIQUE

Distinct count571989
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
ebf2370765ab5e9044bd7e37ac0144bb
 
1
e32f66bde67cc1c2958aee567ec83912
 
1
80cf6f35d5d855d3b8092bce0f2558d1
 
1
c343fb1603092d9ec329d585a937f1f9
 
1
5330cf3f61ba5fb16cd5e6583eb29fbe
 
1
Other values (571984)
571984
ValueCountFrequency (%) 
ebf2370765ab5e9044bd7e37ac0144bb1< 0.1%
 
e32f66bde67cc1c2958aee567ec839121< 0.1%
 
80cf6f35d5d855d3b8092bce0f2558d11< 0.1%
 
c343fb1603092d9ec329d585a937f1f91< 0.1%
 
5330cf3f61ba5fb16cd5e6583eb29fbe1< 0.1%
 
9bf21117773499546dccf773c03499ed1< 0.1%
 
140cf9d565c57a063b797051b6006c531< 0.1%
 
a2bbb956396b67a2bbe1940be96b00c41< 0.1%
 
c125c033f32692b3329b77a53bdd82491< 0.1%
 
3caa42a79dd0e9a5c381d9a4ddcb6d5b1< 0.1%
 
Other values (571979)571979> 99.9%
 
2021-04-07T09:30:40.877805image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length32
Median length32
Mean length31.99996853
Min length14

country_code
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
JP
571988
ZZ
 
1
ValueCountFrequency (%) 
JP571988> 99.9%
 
ZZ1< 0.1%
 
2021-04-07T09:30:41.217258image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length2
Median length2
Mean length2
Min length2

hco_source_id
Categorical

UNIQUE

Distinct count571989
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
0011000000Ui0leAAB
 
1
0015F000017ZO5FQAW
 
1
00110000013KeubAAC
 
1
0011000000UiLwRAAV
 
1
0011000000UOHV5AAP
 
1
Other values (571984)
571984
ValueCountFrequency (%) 
0011000000Ui0leAAB1< 0.1%
 
0015F000017ZO5FQAW1< 0.1%
 
00110000013KeubAAC1< 0.1%
 
0011000000UiLwRAAV1< 0.1%
 
0011000000UOHV5AAP1< 0.1%
 
0011000000UfVUeAAN1< 0.1%
 
0011000000UiEhUAAV1< 0.1%
 
0011000000UOJexAAH1< 0.1%
 
0011000000UgWINAA31< 0.1%
 
0011000000UfeswAAB1< 0.1%
 
Other values (571979)571979> 99.9%
 
2021-04-07T09:30:48.994557image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length18
Median length18
Mean length17.99999301
Min length14

modify_id
Categorical

HIGH CARDINALITY

Distinct count761
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
00510000000br12AAA
561096
00510000000bxB6AAI
 
1498
00510000000bxABAAY
 
1270
00510000002GX6yAAG
 
270
00510000000bx90AAA
 
257
Other values (756)
 
7598
ValueCountFrequency (%) 
00510000000br12AAA56109698.1%
 
00510000000bxB6AAI14980.3%
 
00510000000bxABAAY12700.2%
 
00510000002GX6yAAG270< 0.1%
 
00510000000bx90AAA257< 0.1%
 
00510000000bx7tAAA235< 0.1%
 
00510000000bx4HAAQ211< 0.1%
 
00510000000bxC8AAI191< 0.1%
 
00510000000bx6PAAQ174< 0.1%
 
00510000000bxCOAAY167< 0.1%
 
Other values (751)66201.2%
 
2021-04-07T09:30:49.328341image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length18
Median length18
Mean length17.99999301
Min length14
Distinct count14924
Unique (%)2.6%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
Minimum2014-02-14 01:26:20
Maximum2021-03-22 16:49:05.119017
2021-04-07T09:30:49.692113image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

hco_business_id
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count555511
Unique (%)> 99.9%
Missing16401
Missing (%)2.9%
Memory size4.4 MiB
188
 
2
256
 
2
321
 
2
125
 
2
072
 
2
Other values (555506)
555578
ValueCountFrequency (%) 
1882< 0.1%
 
2562< 0.1%
 
3212< 0.1%
 
1252< 0.1%
 
0722< 0.1%
 
2532< 0.1%
 
2502< 0.1%
 
1692< 0.1%
 
2022< 0.1%
 
0332< 0.1%
 
Other values (555501)55556897.1%
 
(Missing)164012.9%
 
2021-04-07T09:30:58.028513image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length7
Mean length6.882398088
Min length3

inactive_flag
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.2 MiB
0
571989
ValueCountFrequency (%) 
0571989100.0%
 

inactive_reason
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing571989
Missing (%)100.0%
Memory size4.4 MiB

hco_name
Categorical

HIGH CARDINALITY

Distinct count443574
Unique (%)77.5%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
不明
 
866
鈴木歯科医院
 
260
田中歯科医院
 
245
ひまわり薬局
 
222
佐藤歯科医院
 
217
Other values (443569)
570179
ValueCountFrequency (%) 
不明8660.2%
 
鈴木歯科医院260< 0.1%
 
田中歯科医院245< 0.1%
 
ひまわり薬局222< 0.1%
 
佐藤歯科医院217< 0.1%
 
小林歯科医院212< 0.1%
 
山本歯科医院212< 0.1%
 
中村歯科医院188< 0.1%
 
吉田歯科医院172< 0.1%
 
加藤歯科医院166< 0.1%
 
Other values (443564)56922999.5%
 
2021-04-07T09:31:04.502495image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length39
Median length10
Mean length9.906485964
Min length1

hco_type
Categorical

HIGH CORRELATION
MISSING

Distinct count7
Unique (%)< 0.1%
Missing16401
Missing (%)2.9%
Memory size4.4 MiB
アルトマーク施設
546096
アルトマーク購入外施設
 
8972
学会(学会事務局)
 
336
流通業者(組織)
 
125
医師会
 
47
Other values (2)
 
12
ValueCountFrequency (%) 
アルトマーク施設54609695.5%
 
アルトマーク購入外施設89721.6%
 
学会(学会事務局)3360.1%
 
流通業者(組織)125< 0.1%
 
医師会47< 0.1%
 
患者団体11< 0.1%
 
Not Applicable1< 0.1%
 
(Missing)164012.9%
 
2021-04-07T09:31:04.860927image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length8
Mean length7.903798849
Min length3

hco_type_english_name
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing571989
Missing (%)100.0%
Memory size4.4 MiB

sector
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing571989
Missing (%)100.0%
Memory size4.4 MiB

phone_number
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count478218
Unique (%)85.5%
Missing12683
Missing (%)2.2%
Memory size4.4 MiB
0
 
58
011-716-2111
 
26
092-641-1151
 
26
00-0000-0000
 
25
03-3813-6111
 
24
Other values (478213)
559147
ValueCountFrequency (%) 
058< 0.1%
 
011-716-211126< 0.1%
 
092-641-115126< 0.1%
 
00-0000-000025< 0.1%
 
03-3813-611124< 0.1%
 
019-651-511122< 0.1%
 
03-3353-811122< 0.1%
 
025-223-616121< 0.1%
 
06-6877-511120< 0.1%
 
03-3434-768120< 0.1%
 
Other values (478208)55904297.7%
 
(Missing)126832.2%
 
2021-04-07T09:31:12.250897image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length15
Median length12
Mean length11.79890348
Min length1

fax_number
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing571989
Missing (%)100.0%
Memory size4.4 MiB

website
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing571989
Missing (%)100.0%
Memory size4.4 MiB

territory_name
Categorical

MISSING

Distinct count1
Unique (%)100.0%
Missing571988
Missing (%)> 99.9%
Memory size4.4 MiB
Not Applicable
1
ValueCountFrequency (%) 
Not Applicable1< 0.1%
 
(Missing)571988> 99.9%
 
2021-04-07T09:31:12.563195image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000019231
Min length3

formatted_name
Categorical

HIGH CARDINALITY

Distinct count443574
Unique (%)77.5%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
不明
 
866
鈴木歯科医院
 
260
田中歯科医院
 
245
ひまわり薬局
 
222
佐藤歯科医院
 
217
Other values (443569)
570179
ValueCountFrequency (%) 
不明8660.2%
 
鈴木歯科医院260< 0.1%
 
田中歯科医院245< 0.1%
 
ひまわり薬局222< 0.1%
 
佐藤歯科医院217< 0.1%
 
小林歯科医院212< 0.1%
 
山本歯科医院212< 0.1%
 
中村歯科医院188< 0.1%
 
吉田歯科医院172< 0.1%
 
加藤歯科医院166< 0.1%
 
Other values (443564)56922999.5%
 
2021-04-07T09:31:19.944000image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length39
Median length10
Mean length9.906485964
Min length1

remarks
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing571989
Missing (%)100.0%
Memory size4.4 MiB

beds
Categorical

HIGH CARDINALITY
MISSING

Distinct count707
Unique (%)0.3%
Missing309343
Missing (%)54.1%
Memory size4.4 MiB
0
229217
19
 
4706
50
 
3945
100
 
2295
80
 
1377
Other values (702)
 
21106
ValueCountFrequency (%) 
022921740.1%
 
1947060.8%
 
5039450.7%
 
10022950.4%
 
8013770.2%
 
609050.2%
 
706260.1%
 
36070.1%
 
105990.1%
 
185100.1%
 
Other values (697)178593.1%
 
(Missing)30934354.1%
 
2021-04-07T09:31:20.434731image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length4
Median length3
Mean length2.148892723
Min length1

jp_hco_category
Categorical

HIGH CORRELATION
MISSING

Distinct count7
Unique (%)< 0.1%
Missing16401
Missing (%)2.9%
Memory size4.4 MiB
アルトマーク施設
546096
アルトマーク購入外施設
 
8972
学会(学会事務局)
 
336
流通業者(組織)
 
125
医師会
 
47
Other values (2)
 
12
ValueCountFrequency (%) 
アルトマーク施設54609695.5%
 
アルトマーク購入外施設89721.6%
 
学会(学会事務局)3360.1%
 
流通業者(組織)125< 0.1%
 
医師会47< 0.1%
 
患者団体11< 0.1%
 
Not Applicable1< 0.1%
 
(Missing)164012.9%
 
2021-04-07T09:31:20.870359image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length8
Mean length7.903798849
Min length3

jp_hco_id
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count555511
Unique (%)> 99.9%
Missing16401
Missing (%)2.9%
Memory size4.4 MiB
188
 
2
256
 
2
321
 
2
125
 
2
072
 
2
Other values (555506)
555578
ValueCountFrequency (%) 
1882< 0.1%
 
2562< 0.1%
 
3212< 0.1%
 
1252< 0.1%
 
0722< 0.1%
 
2532< 0.1%
 
2502< 0.1%
 
1692< 0.1%
 
2022< 0.1%
 
0332< 0.1%
 
Other values (555501)55556897.1%
 
(Missing)164012.9%
 
2021-04-07T09:31:30.768323image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length10
Median length7
Mean length6.882377109
Min length2

jp_hospital_type
Categorical

HIGH CORRELATION
MISSING

Distinct count3
Unique (%)< 0.1%
Missing17938
Missing (%)3.1%
Memory size4.4 MiB
GP
548088
HP
 
5962
Not Applicable
 
1
ValueCountFrequency (%) 
GP54808895.8%
 
HP59621.0%
 
Not Applicable1< 0.1%
 
(Missing)179383.1%
 
2021-04-07T09:31:31.282384image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length2
Mean length2.031381722
Min length2

jp_account_furigana
Categorical

HIGH CARDINALITY
MISSING

Distinct count412648
Unique (%)73.2%
Missing8498
Missing (%)1.5%
Memory size4.4 MiB
スズキシカイイン
 
296
タナカシカイイン
 
289
サトウシカイイン
 
286
ヤマモトシカイイン
 
236
コバヤシシカイイン
 
235
Other values (412643)
562149
ValueCountFrequency (%) 
スズキシカイイン2960.1%
 
タナカシカイイン2890.1%
 
サトウシカイイン2860.1%
 
ヤマモトシカイイン236< 0.1%
 
コバヤシシカイイン235< 0.1%
 
タカハシシカイイン235< 0.1%
 
ワタナベシカイイン226< 0.1%
 
イトウシカイイン225< 0.1%
 
ヒマワリヤツキヨク221< 0.1%
 
ナカムラシカイイン220< 0.1%
 
Other values (412638)56102298.1%
 
(Missing)84981.5%
 
2021-04-07T09:31:37.674483image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length40
Median length14
Mean length14.09853336
Min length1

jp_hco_name
Categorical

HIGH CARDINALITY

Distinct count484174
Unique (%)85.3%
Missing4250
Missing (%)0.7%
Memory size4.4 MiB
不明
 
291
鈴木歯科医院
 
258
田中歯科医院
 
243
佐藤歯科医院
 
213
山本歯科医院
 
212
Other values (484169)
566522
ValueCountFrequency (%) 
不明2910.1%
 
鈴木歯科医院258< 0.1%
 
田中歯科医院243< 0.1%
 
佐藤歯科医院213< 0.1%
 
山本歯科医院212< 0.1%
 
小林歯科医院212< 0.1%
 
中村歯科医院188< 0.1%
 
吉田歯科医院172< 0.1%
 
加藤歯科医院166< 0.1%
 
山田歯科医院163< 0.1%
 
Other values (484164)56562198.9%
 
(Missing)42500.7%
 
2021-04-07T09:31:44.549605image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length62
Median length12
Mean length13.64364
Min length1

jp_hco_name_kana
Categorical

HIGH CARDINALITY
MISSING

Distinct count461518
Unique (%)81.9%
Missing8572
Missing (%)1.5%
Memory size4.4 MiB
スズキシカイイン
 
295
タナカシカイイン
 
287
サトウシカイイン
 
284
ヤマモトシカイイン
 
236
コバヤシシカイイン
 
235
Other values (461513)
562080
ValueCountFrequency (%) 
スズキシカイイン2950.1%
 
タナカシカイイン2870.1%
 
サトウシカイイン284< 0.1%
 
ヤマモトシカイイン236< 0.1%
 
コバヤシシカイイン235< 0.1%
 
タカハシシカイイン233< 0.1%
 
ワタナベシカイイン226< 0.1%
 
イトウシカイイン223< 0.1%
 
ナカムラシカイイン221< 0.1%
 
ヨシダシカイイン201< 0.1%
 
Other values (461508)56097698.1%
 
(Missing)85721.5%
 
2021-04-07T09:31:51.032916image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length80
Median length20
Mean length21.91655784
Min length1

jp_hco_shortname
Categorical

HIGH CARDINALITY
MISSING

Distinct count439543
Unique (%)78.0%
Missing8582
Missing (%)1.5%
Memory size4.4 MiB
鈴木歯科医院
 
259
田中歯科医院
 
245
佐藤歯科医院
 
215
ひまわり薬局
 
214
小林歯科医院
 
212
Other values (439538)
562262
ValueCountFrequency (%) 
鈴木歯科医院259< 0.1%
 
田中歯科医院245< 0.1%
 
佐藤歯科医院215< 0.1%
 
ひまわり薬局214< 0.1%
 
小林歯科医院212< 0.1%
 
山本歯科医院212< 0.1%
 
中村歯科医院188< 0.1%
 
吉田歯科医院172< 0.1%
 
加藤歯科医院166< 0.1%
 
山田歯科医院163< 0.1%
 
Other values (439533)56136198.1%
 
(Missing)85821.5%
 
2021-04-07T09:31:57.900042image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length29
Median length10
Mean length9.825648745
Min length1

jp_hco_shortname_kana
Categorical

HIGH CARDINALITY
MISSING

Distinct count412587
Unique (%)73.2%
Missing8620
Missing (%)1.5%
Memory size4.4 MiB
スズキシカイイン
 
296
タナカシカイイン
 
289
サトウシカイイン
 
286
ヤマモトシカイイン
 
236
タカハシシカイイン
 
235
Other values (412582)
562027
ValueCountFrequency (%) 
スズキシカイイン2960.1%
 
タナカシカイイン2890.1%
 
サトウシカイイン2860.1%
 
ヤマモトシカイイン236< 0.1%
 
タカハシシカイイン235< 0.1%
 
コバヤシシカイイン235< 0.1%
 
ワタナベシカイイン226< 0.1%
 
イトウシカイイン225< 0.1%
 
ヒマワリヤツキヨク221< 0.1%
 
ナカムラシカイイン220< 0.1%
 
Other values (412577)56090098.1%
 
(Missing)86201.5%
 
2021-04-07T09:32:05.761890image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length40
Median length15
Mean length15.45346327
Min length1

jp_management_large_class
Categorical

HIGH CORRELATION
MISSING

Distinct count5
Unique (%)< 0.1%
Missing102766
Missing (%)18.0%
Memory size4.4 MiB
その他
444554
公的
 
18581
社会保険
 
3592
国立
 
2495
Not Applicable
 
1
ValueCountFrequency (%) 
その他44455477.7%
 
公的185813.2%
 
社会保険35920.6%
 
国立24950.4%
 
Not Applicable1< 0.1%
 
(Missing)10276618.0%
 
2021-04-07T09:32:06.175923image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length2.96945221
Min length2

jp_management_small_class
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct count63
Unique (%)< 0.1%
Missing102766
Missing (%)18.0%
Memory size4.4 MiB
個人
160231
会社
147694
医療
91732
社福
35423
市立
 
9156
Other values (58)
 
24987
ValueCountFrequency (%) 
個人16023128.0%
 
会社14769425.8%
 
医療9173216.0%
 
社福354236.2%
 
市立91561.6%
 
町立37930.7%
 
健保24080.4%
 
財団20010.3%
 
県立15610.3%
 
学校14790.3%
 
Other values (53)137452.4%
 
(Missing)10276618.0%
 
2021-04-07T09:32:06.604595image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length2
Mean length2.187344512
Min length2

jp_hco_hpgp_class
Categorical

HIGH CORRELATION
MISSING

Distinct count3
Unique (%)< 0.1%
Missing17938
Missing (%)3.1%
Memory size4.4 MiB
GP
548088
HP
 
5962
Not Applicable
 
1
ValueCountFrequency (%) 
GP54808895.8%
 
HP59621.0%
 
Not Applicable1< 0.1%
 
(Missing)179383.1%
 
2021-04-07T09:32:06.958531image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length2
Mean length2.031381722
Min length2

jp_hco_class
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct count89
Unique (%)< 0.1%
Missing25936
Missing (%)4.5%
Memory size4.4 MiB
一般診療所
144448
調剤薬局
99310
歯科診療所
75751
店舗販売業(B)(旧薬種商販売業)
41296
店舗販売業(A)
 
20887
Other values (84)
164361
ValueCountFrequency (%) 
一般診療所14444825.3%
 
調剤薬局9931017.4%
 
歯科診療所7575113.2%
 
店舗販売業(B)(旧薬種商販売業)412967.2%
 
店舗販売業(A)208873.7%
 
グループホーム122052.1%
 
病院(大学HP以外)109801.9%
 
老人デイサービスセンター(ケアセンター)107131.9%
 
特別養護老人ホーム等医務室103101.8%
 
卸会社96001.7%
 
Other values (79)11055319.3%
 
(Missing)259364.5%
 
2021-04-07T09:32:07.379139image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length24
Median length5
Mean length6.906513936
Min length1

jp_hco_kind_code
Categorical

HIGH CORRELATION
MISSING

Distinct count9
Unique (%)< 0.1%
Missing325493
Missing (%)56.9%
Memory size4.4 MiB
7
135351
9
101428
1
 
8552
2
 
1141
4
 
14
Other values (4)
 
10
ValueCountFrequency (%) 
713535123.7%
 
910142817.7%
 
185521.5%
 
211410.2%
 
414< 0.1%
 
54< 0.1%
 
33< 0.1%
 
62< 0.1%
 
Not Applicable1< 0.1%
 
(Missing)32549356.9%
 
2021-04-07T09:32:07.814206image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length2.138132027
Min length1

jp_hco_kind
Categorical

HIGH CORRELATION
MISSING

Distinct count9
Unique (%)< 0.1%
Missing325493
Missing (%)56.9%
Memory size4.4 MiB
診療所
135351
その他
101428
一般
 
8552
精神
 
1141
ハンセン
 
14
Other values (4)
 
10
ValueCountFrequency (%) 
診療所13535123.7%
 
その他10142817.7%
 
一般85521.5%
 
精神11410.2%
 
ハンセン14< 0.1%
 
伝染4< 0.1%
 
結核3< 0.1%
 
歯科2< 0.1%
 
Not Applicable1< 0.1%
 
(Missing)32549356.9%
 
2021-04-07T09:32:08.711174image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length2.983081842
Min length2

jp_psychiatric_ward_nursing_type
Categorical

HIGH CORRELATION
MISSING

Distinct count2
Unique (%)66.7%
Missing571986
Missing (%)> 99.9%
Memory size4.4 MiB
M999
2
Not Applicable
1
ValueCountFrequency (%) 
M9992< 0.1%
 
Not Applicable1< 0.1%
 
(Missing)571986> 99.9%
 
2021-04-07T09:32:09.077065image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000022728
Min length3

jp_related_univ_parent
Categorical

HIGH CARDINALITY
MISSING

Distinct count195
Unique (%)15.7%
Missing570747
Missing (%)99.8%
Memory size4.4 MiB
5302823
 
40
3613814
 
32
5408060
 
32
8104657
 
29
3613809
 
25
Other values (190)
1084
ValueCountFrequency (%) 
530282340< 0.1%
 
361381432< 0.1%
 
540806032< 0.1%
 
810465729< 0.1%
 
361380925< 0.1%
 
230148720< 0.1%
 
361381620< 0.1%
 
110375920< 0.1%
 
370483119< 0.1%
 
490435518< 0.1%
 
Other values (185)9870.2%
 
(Missing)57074799.8%
 
2021-04-07T09:32:09.480574image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.00869772
Min length3

jp_open_close_business_date
Categorical

HIGH CARDINALITY
MISSING

Distinct count175
Unique (%)10.1%
Missing570253
Missing (%)99.7%
Memory size4.4 MiB
202104
 
224
202103
 
115
202102
 
110
202009
 
77
202101
 
68
Other values (170)
1142
ValueCountFrequency (%) 
202104224< 0.1%
 
202103115< 0.1%
 
202102110< 0.1%
 
20200977< 0.1%
 
20210168< 0.1%
 
20201267< 0.1%
 
20200254< 0.1%
 
20210547< 0.1%
 
20200143< 0.1%
 
20200643< 0.1%
 
Other values (165)8880.2%
 
(Missing)57025399.7%
 
2021-04-07T09:32:09.874553image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length6
Median length3
Mean length3.00909458
Min length2

jp_hco_rep_code
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count188418
Unique (%)94.1%
Missing371832
Missing (%)65.0%
Memory size4.4 MiB
284757
 
9
144553
 
7
153438
 
6
297935
 
6
221424
 
6
Other values (188413)
200123
ValueCountFrequency (%) 
2847579< 0.1%
 
1445537< 0.1%
 
1534386< 0.1%
 
2979356< 0.1%
 
2214246< 0.1%
 
3083016< 0.1%
 
1262095< 0.1%
 
1901085< 0.1%
 
6224665< 0.1%
 
2499105< 0.1%
 
Other values (188408)20009735.0%
 
(Missing)37183265.0%
 
2021-04-07T09:32:13.961451image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length4.04980865
Min length3

jp_hco_rep_kana
Categorical

HIGH CARDINALITY
MISSING

Distinct count211186
Unique (%)56.2%
Missing195961
Missing (%)34.3%
Memory size4.4 MiB
マツモト タダヒサ
 
2017
ツカモト アツシ
 
1559
スギウラ カツノリ
 
1423
ヤハタ マサヒロ
 
1292
ヨコヤマ ヒデアキ
 
1152
Other values (211181)
368585
ValueCountFrequency (%) 
マツモト タダヒサ20170.4%
 
ツカモト アツシ15590.3%
 
スギウラ カツノリ14230.2%
 
ヤハタ マサヒロ12920.2%
 
ヨコヤマ ヒデアキ11520.2%
 
サダカタ ヒロシ10330.2%
 
オオイシ ミヤ10080.2%
 
オオタ タカオ9800.2%
 
タカヤナギ マサユキ8050.1%
 
モリ カナメ7680.1%
 
Other values (211176)36399163.6%
 
(Missing)19596134.3%
 
2021-04-07T09:32:17.853111image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length20
Median length8
Mean length6.827126046
Min length3

jp_hco_rep_kanji
Categorical

HIGH CARDINALITY
MISSING

Distinct count247490
Unique (%)65.8%
Missing195952
Missing (%)34.3%
Memory size4.4 MiB
松本 忠久
 
2020
塚本 厚志
 
1559
杉浦 克典
 
1423
八幡 政浩
 
1292
横山 英昭
 
1150
Other values (247485)
368593
ValueCountFrequency (%) 
松本 忠久20200.4%
 
塚本 厚志15590.3%
 
杉浦 克典14230.2%
 
八幡 政浩12920.2%
 
横山 英昭11500.2%
 
大石 美也10870.2%
 
貞方 宏司10330.2%
 
大田 貴雄9810.2%
 
高柳 昌幸8100.1%
 
森 要7680.1%
 
Other values (247480)36391463.6%
 
(Missing)19595234.3%
 
2021-04-07T09:32:22.530573image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length20
Median length5
Mean length4.344251375
Min length3

jp_hco_pharmacy_class
Categorical

HIGH CORRELATION
MISSING

Distinct count4
Unique (%)< 0.1%
Missing25122
Missing (%)4.4%
Memory size4.4 MiB
病院
247099
薬局薬店
212685
歯科
87082
Not Applicable
 
1
ValueCountFrequency (%) 
病院24709943.2%
 
薬局薬店21268537.2%
 
歯科8708215.2%
 
Not Applicable1< 0.1%
 
(Missing)251224.4%
 
2021-04-07T09:32:23.267561image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length2
Mean length2.787609552
Min length2

hco_dcf_cd
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count554052
Unique (%)100.0%
Missing17937
Missing (%)3.1%
Memory size4.4 MiB
3695800
 
1
5602716
 
1
8107638
 
1
8871402
 
1
4875830
 
1
Other values (554047)
554047
ValueCountFrequency (%) 
36958001< 0.1%
 
56027161< 0.1%
 
81076381< 0.1%
 
88714021< 0.1%
 
48758301< 0.1%
 
54103851< 0.1%
 
37704071< 0.1%
 
37780601< 0.1%
 
83023051< 0.1%
 
01980541< 0.1%
 
Other values (554042)55404296.9%
 
(Missing)179373.1%
 
2021-04-07T09:32:34.450661image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length7
Mean length6.874578008
Min length3

jp_duplicate_hco_code
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count13366
Unique (%)99.5%
Missing558552
Missing (%)97.7%
Memory size4.4 MiB
0202955
 
3
0200953
 
3
0203403
 
3
0212941
 
3
3693616
 
3
Other values (13361)
13422
ValueCountFrequency (%) 
02029553< 0.1%
 
02009533< 0.1%
 
02034033< 0.1%
 
02129413< 0.1%
 
36936163< 0.1%
 
02281263< 0.1%
 
36856473< 0.1%
 
55125232< 0.1%
 
36948882< 0.1%
 
41008752< 0.1%
 
Other values (13356)134102.3%
 
(Missing)55855297.7%
 
2021-04-07T09:32:34.960377image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length7
Median length3
Mean length3.093958101
Min length2

jp_permitted_beds
Categorical

HIGH CARDINALITY
MISSING

Distinct count728
Unique (%)0.4%
Missing394927
Missing (%)69.0%
Memory size4.4 MiB
0
155967
19
 
4457
3
 
583
10
 
531
9
 
462
Other values (723)
 
15062
ValueCountFrequency (%) 
015596727.3%
 
1944570.8%
 
35830.1%
 
105310.1%
 
94620.1%
 
24610.1%
 
184520.1%
 
54270.1%
 
84230.1%
 
603940.1%
 
Other values (718)129052.3%
 
(Missing)39492769.0%
 
2021-04-07T09:32:35.339381image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length4
Median length3
Mean length2.421803566
Min length1

jp_psychiatric_ward_number
Categorical

MISSING

Distinct count1
Unique (%)100.0%
Missing571988
Missing (%)> 99.9%
Memory size4.4 MiB
0
1
ValueCountFrequency (%) 
01< 0.1%
 
(Missing)571988> 99.9%
 
2021-04-07T09:32:35.735674image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.999996503
Min length1

jp_psychosis_hospital_bed_number
Categorical

HIGH CORRELATION
MISSING

Distinct count2
Unique (%)66.7%
Missing571986
Missing (%)> 99.9%
Memory size4.4 MiB
90
2
0
1
ValueCountFrequency (%) 
902< 0.1%
 
01< 0.1%
 
(Missing)571986> 99.9%
 
2021-04-07T09:32:36.153696image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.999993007
Min length1

record_type_name
Categorical

HIGH CORRELATION

Distinct count11
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
Hospital
262978
Pharmacy
120438
Deleted_Pharmacy_jpkk
92164
Deleted_Hospital_jpkk
78470
Other_Group_jpkk
 
9357
Other values (6)
 
8582
ValueCountFrequency (%) 
Hospital26297846.0%
 
Pharmacy12043821.1%
 
Deleted_Pharmacy_jpkk9216416.1%
 
Deleted_Hospital_jpkk7847013.7%
 
Other_Group_jpkk93571.6%
 
Dummy_CCHospital_jpkk84351.5%
 
Distributor125< 0.1%
 
Dummy_Hospital_jpro11< 0.1%
 
Deleted_Other_Group_jpkk9< 0.1%
 
Not Applicable1< 0.1%
 
2021-04-07T09:32:36.636029image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length24
Median length8
Mean length12.20185178
Min length8

hco_external_id
Categorical

HIGH CARDINALITY

Distinct count563543
Unique (%)98.5%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
Not Applicable
 
8447
H6502127
 
1
H3631256
 
1
H6572526
 
1
H8179345
 
1
Other values (563538)
563538
ValueCountFrequency (%) 
Not Applicable84471.5%
 
H65021271< 0.1%
 
H36312561< 0.1%
 
H65725261< 0.1%
 
H81793451< 0.1%
 
H55102781< 0.1%
 
H26729441< 0.1%
 
H01996971< 0.1%
 
H57019031< 0.1%
 
H45000471< 0.1%
 
Other values (563533)56353398.5%
 
2021-04-07T09:32:46.246111image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length8
Mean length8.085686963
Min length4

parent_hco_key
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count571988
Unique (%)> 99.9%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
527c19146847d4779023703fb2870825
 
2
ebf2370765ab5e9044bd7e37ac0144bb
 
1
9bf21117773499546dccf773c03499ed
 
1
0a1b8b46bc93bdc591dfa97e339c6935
 
1
7d66f9043d8b75543891eb8c41cf0be0
 
1
Other values (571983)
571983
ValueCountFrequency (%) 
527c19146847d4779023703fb28708252< 0.1%
 
ebf2370765ab5e9044bd7e37ac0144bb1< 0.1%
 
9bf21117773499546dccf773c03499ed1< 0.1%
 
0a1b8b46bc93bdc591dfa97e339c69351< 0.1%
 
7d66f9043d8b75543891eb8c41cf0be01< 0.1%
 
f3d16e58c7aecdd64b4a6b2f0af7100b1< 0.1%
 
80cf6f35d5d855d3b8092bce0f2558d11< 0.1%
 
c343fb1603092d9ec329d585a937f1f91< 0.1%
 
5330cf3f61ba5fb16cd5e6583eb29fbe1< 0.1%
 
140cf9d565c57a063b797051b6006c531< 0.1%
 
Other values (571978)571978> 99.9%
 
2021-04-07T09:32:55.391085image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length32
Median length32
Mean length31.99996853
Min length14

parent_hco_name
Categorical

HIGH CARDINALITY

Distinct count443573
Unique (%)77.5%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
不明
 
866
鈴木歯科医院
 
260
田中歯科医院
 
245
ひまわり薬局
 
222
佐藤歯科医院
 
217
Other values (443568)
570179
ValueCountFrequency (%) 
不明8660.2%
 
鈴木歯科医院260< 0.1%
 
田中歯科医院245< 0.1%
 
ひまわり薬局222< 0.1%
 
佐藤歯科医院217< 0.1%
 
小林歯科医院212< 0.1%
 
山本歯科医院212< 0.1%
 
中村歯科医院188< 0.1%
 
吉田歯科医院172< 0.1%
 
加藤歯科医院166< 0.1%
 
Other values (443563)56922999.5%
 
2021-04-07T09:33:05.335307image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length39
Median length10
Mean length9.906478971
Min length1

deleted_flag
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.2 MiB
0
571989
ValueCountFrequency (%) 
0571989100.0%
 

address_line_1
Categorical

HIGH CARDINALITY
MISSING

Distinct count60991
Unique (%)10.8%
Missing8457
Missing (%)1.5%
Memory size4.4 MiB
レコード終了により更新停止
 
11111
記載なし
 
850
東京都中央区銀座
 
841
東京都新宿区西新宿
 
744
東京都新宿区新宿
 
501
Other values (60986)
549485
ValueCountFrequency (%) 
レコード終了により更新停止111111.9%
 
記載なし8500.1%
 
東京都中央区銀座8410.1%
 
東京都新宿区西新宿7440.1%
 
東京都新宿区新宿5010.1%
 
東京都文京区本郷5000.1%
 
東京都港区赤坂4520.1%
 
福岡県福岡市中央区天神4210.1%
 
愛知県名古屋市中区栄4070.1%
 
大阪府大阪市北区梅田3380.1%
 
Other values (60981)54736795.7%
 
(Missing)84571.5%
 
2021-04-07T09:33:07.163889image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length22
Median length10
Mean length10.25193317
Min length3

address_line_2
Categorical

MISSING

Distinct count1
Unique (%)100.0%
Missing571988
Missing (%)> 99.9%
Memory size4.4 MiB
Not Applicable
1
ValueCountFrequency (%) 
Not Applicable1< 0.1%
 
(Missing)571988> 99.9%
 
2021-04-07T09:33:07.733976image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000019231
Min length3

suburb_town
Categorical

MISSING

Distinct count1
Unique (%)100.0%
Missing571988
Missing (%)> 99.9%
Memory size4.4 MiB
Not Applicable
1
ValueCountFrequency (%) 
Not Applicable1< 0.1%
 
(Missing)571988> 99.9%
 
2021-04-07T09:33:08.228881image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000019231
Min length3

city
Categorical

HIGH CARDINALITY
MISSING

Distinct count1345
Unique (%)0.2%
Missing8853
Missing (%)1.5%
Memory size4.4 MiB
世田谷区
 
4229
港区
 
3889
新宿区
 
3389
大田区
 
3294
鹿児島市
 
3248
Other values (1340)
545087
ValueCountFrequency (%) 
世田谷区42290.7%
 
港区38890.7%
 
新宿区33890.6%
 
大田区32940.6%
 
鹿児島市32480.6%
 
中央区30670.5%
 
千代田区29480.5%
 
練馬区28560.5%
 
渋谷区26260.5%
 
長崎市26000.5%
 
Other values (1335)53099092.8%
 
(Missing)88531.5%
 
2021-04-07T09:33:08.924186image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.836673433
Min length2

state
Categorical

HIGH CORRELATION
MISSING

Distinct count49
Unique (%)< 0.1%
Missing8896
Missing (%)1.6%
Memory size4.4 MiB
東京都
 
71725
大阪府
 
42944
神奈川県
 
34562
愛知県
 
28738
福岡県
 
25661
Other values (44)
359463
ValueCountFrequency (%) 
東京都7172512.5%
 
大阪府429447.5%
 
神奈川県345626.0%
 
愛知県287385.0%
 
福岡県256614.5%
 
埼玉県249314.4%
 
兵庫県243194.3%
 
北海道237854.2%
 
千葉県213743.7%
 
静岡県151482.6%
 
Other values (39)24990643.7%
 
2021-04-07T09:33:09.684585image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.083741121
Min length2

postcode
Categorical

HIGH CARDINALITY
MISSING

Distinct count62225
Unique (%)11.1%
Missing9617
Missing (%)1.7%
Memory size4.4 MiB
104-0061
 
843
160-0023
 
744
160-0022
 
501
113-0033
 
500
107-0052
 
449
Other values (62220)
559335
ValueCountFrequency (%) 
104-00618430.1%
 
160-00237440.1%
 
160-00225010.1%
 
113-00335000.1%
 
107-00524490.1%
 
810-00014210.1%
 
460-00084070.1%
 
530-00013380.1%
 
107-00623350.1%
 
151-00533020.1%
 
Other values (62215)55753297.5%
 
(Missing)96171.7%
 
2021-04-07T09:33:11.431365image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length8
Mean length7.915113752
Min length3

brick
Categorical

MISSING

Distinct count1
Unique (%)100.0%
Missing571988
Missing (%)> 99.9%
Memory size4.4 MiB
Not Applicable
1
ValueCountFrequency (%) 
Not Applicable1< 0.1%
 
(Missing)571988> 99.9%
 
2021-04-07T09:33:12.045928image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000019231
Min length3

map
Categorical

HIGH CARDINALITY
MISSING

Distinct count62234
Unique (%)11.0%
Missing8457
Missing (%)1.5%
Memory size4.4 MiB
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都中央区銀座+中央区" target="_blank">map</a>
 
841
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都新宿区西新宿+新宿区" target="_blank">map</a>
 
744
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都新宿区新宿+新宿区" target="_blank">map</a>
 
501
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都文京区本郷+文京区" target="_blank">map</a>
 
500
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都港区赤坂+港区" target="_blank">map</a>
 
452
Other values (62229)
560494
ValueCountFrequency (%) 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都中央区銀座+中央区" target="_blank">map</a>8410.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都新宿区西新宿+新宿区" target="_blank">map</a>7440.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都新宿区新宿+新宿区" target="_blank">map</a>5010.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都文京区本郷+文京区" target="_blank">map</a>5000.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都港区赤坂+港区" target="_blank">map</a>4520.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=福岡県福岡市中央区天神+福岡市中央区" target="_blank">map</a>4210.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=愛知県名古屋市中区栄+名古屋市中区" target="_blank">map</a>4070.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=記載なし+" target="_blank">map</a>3960.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=大阪府大阪市北区梅田+大阪市北区" target="_blank">map</a>3380.1%
 
<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=東京都港区南青山+港区" target="_blank">map</a>3370.1%
 
Other values (62224)55859597.7%
 
(Missing)84571.5%
 
2021-04-07T09:33:14.235072image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length113
Median length96
Mean length95.81482861
Min length3

hco_address_source_id
Categorical

HIGH CARDINALITY

Distinct count563531
Unique (%)98.5%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
Not Applicable
 
8458
a0110000009p0NDAAY
 
2
a0110000009qJRpAAM
 
1
a0110000009pD2SAAU
 
1
a0110000009pwYgAAI
 
1
Other values (563526)
563526
ValueCountFrequency (%) 
Not Applicable84581.5%
 
a0110000009p0NDAAY2< 0.1%
 
a0110000009qJRpAAM1< 0.1%
 
a0110000009pD2SAAU1< 0.1%
 
a0110000009pwYgAAI1< 0.1%
 
a0110000009oTWFAA21< 0.1%
 
a0110000009qpdiAAA1< 0.1%
 
a0110000009phJYAAY1< 0.1%
 
a0110000009pm05AAA1< 0.1%
 
a0110000009qnR8AAI1< 0.1%
 
Other values (563521)56352198.5%
 
2021-04-07T09:33:25.600362image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length18
Median length18
Mean length17.94085201
Min length14

appt_required_flag
Boolean

MISSING

Distinct count1
Unique (%)< 0.1%
Missing8457
Missing (%)1.5%
Memory size4.4 MiB
0
563532
(Missing)
 
8457
ValueCountFrequency (%) 
056353298.5%
 
(Missing)84571.5%
 

address_external_id
Categorical

HIGH CARDINALITY

Distinct count563531
Unique (%)98.5%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
Not Applicable
 
8458
H8700803
 
2
H6502127
 
1
H2672944
 
1
H2401680
 
1
Other values (563526)
563526
ValueCountFrequency (%) 
Not Applicable84581.5%
 
H87008032< 0.1%
 
H65021271< 0.1%
 
H26729441< 0.1%
 
H24016801< 0.1%
 
H36938181< 0.1%
 
H65725261< 0.1%
 
H81793451< 0.1%
 
H55102781< 0.1%
 
H01996971< 0.1%
 
Other values (563521)56352198.5%
 
2021-04-07T09:33:37.378018image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length8
Mean length8.085802349
Min length4

address_phone
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count478111
Unique (%)85.5%
Missing12825
Missing (%)2.2%
Memory size4.4 MiB
0
 
58
092-641-1151
 
26
011-716-2111
 
26
00-0000-0000
 
25
03-3813-6111
 
24
Other values (478106)
559005
ValueCountFrequency (%) 
058< 0.1%
 
092-641-115126< 0.1%
 
011-716-211126< 0.1%
 
00-0000-000025< 0.1%
 
03-3813-611124< 0.1%
 
019-651-511122< 0.1%
 
03-3353-811122< 0.1%
 
025-223-616121< 0.1%
 
03-3434-768120< 0.1%
 
06-6877-511120< 0.1%
 
Other values (478101)55890097.7%
 
(Missing)128252.2%
 
2021-04-07T09:33:48.067140image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length15
Median length12
Mean length11.79685973
Min length1

address_fax
Categorical

MISSING

Distinct count1
Unique (%)100.0%
Missing571988
Missing (%)> 99.9%
Memory size4.4 MiB
Not Applicable
1
ValueCountFrequency (%) 
Not Applicable1< 0.1%
 
(Missing)571988> 99.9%
 
2021-04-07T09:33:48.726878image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000019231
Min length3

primary_flag
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing8457
Missing (%)1.5%
Memory size4.4 MiB
1
563531
0
 
1
(Missing)
 
8457
ValueCountFrequency (%) 
156353198.5%
 
01< 0.1%
 
(Missing)84571.5%
 

jp_prefecture_code
Categorical

HIGH CORRELATION
MISSING

Distinct count49
Unique (%)< 0.1%
Missing8895
Missing (%)1.6%
Memory size4.4 MiB
13
 
71726
27
 
42945
14
 
34563
23
 
28739
40
 
25662
Other values (44)
359459
ValueCountFrequency (%) 
137172612.5%
 
27429457.5%
 
14345636.0%
 
23287395.0%
 
40256624.5%
 
11249324.4%
 
28243204.3%
 
01237864.2%
 
12213753.7%
 
22151492.6%
 
Other values (39)24989743.7%
 
2021-04-07T09:33:49.403960image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length2
Mean length2.015571978
Min length2

jp_local_area_code
Categorical

HIGH CARDINALITY
MISSING

Distinct count355
Unique (%)0.1%
Missing8949
Missing (%)1.6%
Memory size4.4 MiB
201
 
65123
202
 
33042
203
 
28903
204
 
20940
101
 
19264
Other values (350)
395768
ValueCountFrequency (%) 
2016512311.4%
 
202330425.8%
 
203289035.1%
 
204209403.7%
 
101192643.4%
 
205165742.9%
 
207157562.8%
 
103143122.5%
 
206136432.4%
 
102130762.3%
 
Other values (345)32240756.4%
 
2021-04-07T09:33:50.147537image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000019231
Min length3

jp_city_code
Categorical

HIGH CARDINALITY
MISSING

Distinct count1368
Unique (%)0.2%
Missing8853
Missing (%)1.5%
Memory size4.4 MiB
361400
 
4229
362200
 
3889
361100
 
3389
360500
 
3294
870100
 
3248
Other values (1363)
545087
ValueCountFrequency (%) 
36140042290.7%
 
36220038890.7%
 
36110033890.6%
 
36050032940.6%
 
87010032480.6%
 
36160030670.5%
 
36170029480.5%
 
36200028560.5%
 
36100026260.5%
 
83010026000.5%
 
Other values (1358)53099092.8%
 
(Missing)88531.5%
 
2021-04-07T09:33:50.813192image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length6
Median length6
Mean length5.953560296
Min length2

jp_redai_prefecture_code
Categorical

HIGH CORRELATION
MISSING

Distinct count22
Unique (%)17.5%
Missing571863
Missing (%)> 99.9%
Memory size4.4 MiB
99
90
54
 
6
36
 
4
64
 
3
22
 
2
Other values (17)
21
ValueCountFrequency (%) 
9990< 0.1%
 
546< 0.1%
 
364< 0.1%
 
643< 0.1%
 
222< 0.1%
 
882< 0.1%
 
332< 0.1%
 
342< 0.1%
 
812< 0.1%
 
351< 0.1%
 
Other values (12)12< 0.1%
 
(Missing)571863> 99.9%
 
2021-04-07T09:33:51.791186image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length2.999800695
Min length2

jp_larger_section_code
Categorical

HIGH CARDINALITY
MISSING

Distinct count851
Unique (%)0.2%
Missing9214
Missing (%)1.6%
Memory size4.4 MiB
001
 
14112
005
 
12660
002
 
12511
003
 
12477
007
 
11582
Other values (846)
499433
ValueCountFrequency (%) 
001141122.5%
 
005126602.2%
 
002125112.2%
 
003124772.2%
 
007115822.0%
 
004113562.0%
 
006112502.0%
 
008103061.8%
 
01099311.7%
 
00999051.7%
 
Other values (841)44668578.1%
 
2021-04-07T09:33:52.479154image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000019231
Min length3

jp_smaller_section_code
Categorical

HIGH CARDINALITY
MISSING

Distinct count320
Unique (%)0.1%
Missing9261
Missing (%)1.6%
Memory size4.4 MiB
000
241952
001
85701
002
74198
003
51772
004
 
30499
Other values (315)
78606
ValueCountFrequency (%) 
00024195242.3%
 
0018570115.0%
 
0027419813.0%
 
003517729.1%
 
004304995.3%
 
005201163.5%
 
006111341.9%
 
00762501.1%
 
00829110.5%
 
10123260.4%
 
Other values (310)358696.3%
 
(Missing)92611.6%
 
2021-04-07T09:33:53.029207image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.000019231
Min length3

jp_address_furigana
Categorical

HIGH CARDINALITY
MISSING

Distinct count60751
Unique (%)10.8%
Missing9727
Missing (%)1.7%
Memory size4.4 MiB
NO ADDRRES DATA
 
10938
トウキヨウト チユウオウク ギンザ
 
841
トウキヨウト シンジユクク ニシシンジユク
 
744
トウキヨウト シンジユクク シンジユク
 
501
トウキヨウト ブンキヨウク ホンゴウ
 
500
Other values (60746)
548738
ValueCountFrequency (%) 
NO ADDRRES DATA109381.9%
 
トウキヨウト チユウオウク ギンザ8410.1%
 
トウキヨウト シンジユクク ニシシンジユク7440.1%
 
トウキヨウト シンジユクク シンジユク5010.1%
 
トウキヨウト ブンキヨウク ホンゴウ5000.1%
 
トウキヨウト ミナトク アカサカ4520.1%
 
フクオカケン フクオカシ チユウオウク テンジン4210.1%
 
アイチケン ナゴヤシ ナカク サカエ4070.1%
 
オオサカフ オオサカシ キタク ウメダ3380.1%
 
トウキヨウト ミナトク ミナミアオヤマ3370.1%
 
Other values (60741)54678395.6%
 
(Missing)97271.7%
 
2021-04-07T09:33:54.406975image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Length

Max length34
Median length19
Mean length19.91064513
Min length3
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
Minimum2021-03-22 16:48:51.940386
Maximum2021-03-22 16:49:05.119017
2021-04-07T09:33:54.836553image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:33:55.246444image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size4.4 MiB
Minimum2021-03-22 16:48:51.940386
Maximum2021-03-22 16:49:05.119017
2021-04-07T09:33:56.152409image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:33:56.626937image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram

Correlations

2021-04-07T09:33:57.066794image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:33:57.691422image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:33:58.439752image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:33:59.186749image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:34:00.262288image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Missing values

2021-04-07T09:28:25.356947image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:28:50.978354image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:30:02.876638image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-04-07T09:30:18.563560image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Sample

First rows

hco_keycountry_codehco_source_idmodify_idmodify_dthco_business_idinactive_flaginactive_reasonhco_namehco_typehco_type_english_namesectorphone_numberfax_numberwebsiteterritory_nameformatted_nameremarksbedsjp_hco_categoryjp_hco_idjp_hospital_typejp_account_furiganajp_hco_namejp_hco_name_kanajp_hco_shortnamejp_hco_shortname_kanajp_management_large_classjp_management_small_classjp_hco_hpgp_classjp_hco_classjp_hco_kind_codejp_hco_kindjp_psychiatric_ward_nursing_typejp_related_univ_parentjp_open_close_business_datejp_hco_rep_codejp_hco_rep_kanajp_hco_rep_kanjijp_hco_pharmacy_classhco_dcf_cdjp_duplicate_hco_codejp_permitted_bedsjp_psychiatric_ward_numberjp_psychosis_hospital_bed_numberrecord_type_namehco_external_idparent_hco_keyparent_hco_namedeleted_flagaddress_line_1address_line_2suburb_towncitystatepostcodebrickmaphco_address_source_idappt_required_flagaddress_external_idaddress_phoneaddress_faxprimary_flagjp_prefecture_codejp_local_area_codejp_city_codejp_redai_prefecture_codejp_larger_section_codejp_smaller_section_codejp_address_furiganainserted_dateupdated_date
09e9332b37362bb11f505ac9d80f1ecdaJP0011000000kSq5VAAS00510000000br12AAA2016-05-02 04:04:38NaN0NaNアンファ動物病院NaNNaNNaN079-561-1028NaNNaNNaNアンファ動物病院NaN0NaNNaNGPアンフア ドウブツ ビヨウインアンファ動物病院アンフア ドウブツ ビヨウインアンファ動物病院アンフア ドウブツ ビヨウインNaNNaNGPNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNZ031137NaN0NaNNaNDeleted_Hospital_jpkkHZ0311379e9332b37362bb11f505ac9d80f1ecdaアンファ動物病院0兵庫県三田市大原NaNNaN三田市兵庫県669-1515NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=兵庫県三田市大原+三田市" target="_blank">map</a>a011000000JcOQaAAN0.0HZ031137079-561-1028NaN1.028219552100NaN010000ヒヨウゴケン サンダシ オオハラ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
1a40fb2f707dfe9fd1a1aef8653feb5aeJP0011000000q6P6SAAU00510000000br12AAA2014-08-09 06:17:32NaN0NaNスズケン沼津NaNNaNNaNNaNNaNNaNNaNスズケン沼津NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDummy_CCHospital_jpkkNot Applicablea40fb2f707dfe9fd1a1aef8653feb5aeスズケン沼津0NaNNaNNaNNaNNaNNaNNaNNaNNot ApplicableNaNNot ApplicableNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
2fec6bd13bcca93d4916bb5ed83e901d6JP0011000000j3ScNAAU00510000000br12AAA2014-02-21 05:07:56NaN0NaN千葉県薬務課NaNNaNNaNNaNNaNNaNNaN千葉県薬務課NaNNaNNaNNaNNaNNaN千葉県薬務課NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDummy_CCHospital_jpkkNot Applicablefec6bd13bcca93d4916bb5ed83e901d6千葉県薬務課0NaNNaNNaNNaNNaNNaNNaNNaNNot ApplicableNaNNot ApplicableNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
30c485e5c390b438685277a60d9f8efe1JP0011000000q64ssAAA00510000000br12AAA2014-08-06 13:32:52NaN0NaNスミダ病院NaNNaNNaNNaNNaNNaNNaNスミダ病院NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDummy_CCHospital_jpkkNot Applicable0c485e5c390b438685277a60d9f8efe1スミダ病院0NaNNaNNaNNaNNaNNaNNaNNaNNot ApplicableNaNNot ApplicableNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
4541744561ebd2812d4c09dc70d821b35JP0011000000q6P70AAE00510000000br12AAA2014-08-09 06:17:33NaN0NaNコトブキ薬局(大道HP)NaNNaNNaNNaNNaNNaNNaNコトブキ薬局(大道HP)NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDummy_CCHospital_jpkkNot Applicable541744561ebd2812d4c09dc70d821b35コトブキ薬局(大道HP)0NaNNaNNaNNaNNaNNaNNaNNaNNot ApplicableNaNNot ApplicableNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
55ffceca1ce3571f7a374f0b1a4374fffJP0011000000q64upAAA00510000000br12AAA2014-08-06 13:32:55NaN0NaNタガワチョウリツ病院(?)NaNNaNNaNNaNNaNNaNNaNタガワチョウリツ病院(?)NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDummy_CCHospital_jpkkNot Applicable5ffceca1ce3571f7a374f0b1a4374fffタガワチョウリツ病院(?)0NaNNaNNaNNaNNaNNaNNaNNaNNot ApplicableNaNNot ApplicableNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
68385f8b15147c0ed7ffc8b1adfbe12eeJP0011000000UgqaTAAR00510000000br12AAA2016-05-02 04:04:08NaN0NaN前田動物病院NaNNaNNaN0573-68-3600NaNNaNNaN前田動物病院NaN0NaNNaNGPマエダ ドウブツビヨウイン前田動物病院マエダ ドウブツビヨウイン前田動物病院マエダ ドウブツビヨウインNaNNaNGPNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNZ018414NaN0NaNNaNDeleted_Hospital_jpkkHZ0184148385f8b15147c0ed7ffc8b1adfbe12ee前田動物病院0岐阜県中津川市茄子川NaNNaN中津川市岐阜県509-9132NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=岐阜県中津川市茄子川+中津川市" target="_blank">map</a>a0110000009ph4uAAA0.0HZ0184140573-68-3600NaN1.021206470900NaN022000ギフケン ナカツガワシ ナスビガワ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
756b81f66057fd244936d856b65dbc63aJP0011000000UgAoZAAV00510000000br12AAA2016-05-02 04:04:31NaN0NaN串田動物病院NaNNaNNaNNaNNaNNaNNaN串田動物病院NaN0NaNNaNGPクシダドウブツビヨウイン串田動物病院クシダドウブツビヨウイン串田動物病院クシダドウブツビヨウインNaNNaNGPNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNZ000621NaN0NaNNaNDeleted_Hospital_jpkkHZ00062156b81f66057fd244936d856b65dbc63a串田動物病院0京都府京都市西京区NaNNaN京都市西京区京都府615-8085NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=京都府京都市西京区+京都市西京区" target="_blank">map</a>a0110000009p8tZAAQ0.0HZ000621NaNNaN1.026111531000NaN000000キヨウトフ キヨウトシ ニシキヨウク2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
89d8e06f5af86d56ef829ed37953924e8JP0011000000uNGusAAG00510000000br12AAA2016-05-02 04:04:38NaN0NaN㈲さわもと犬猫病院 麻薬NaNNaNNaN095-881-1012NaNNaNNaN㈲さわもと犬猫病院 麻薬NaN0NaNNaNGPユ)サワモトイヌネコビヨウインマヤク㈲さわもと犬猫病院 麻薬ユ)サワモトイヌネコビヨウインマヤク㈲さわもと犬猫病院 麻薬ユ)サワモトイヌネコビヨウインマヤクNaNNaNGPNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNZ031797NaN0NaNNaNDeleted_Hospital_jpkkHZ0317979d8e06f5af86d56ef829ed37953924e8㈲さわもと犬猫病院 麻薬0長崎県西彼杵郡時津町浜田郷NaNNaN西彼杵郡長崎県851-2102NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=長崎県西彼杵郡時津町浜田郷+西彼杵郡" target="_blank">map</a>a011000000Sga04AAB0.0HZ031797095-881-1012NaN1.042308837500NaN007000ナガサキケン ニシソノギグン トギツチヨウ ハマダゴウ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
93331cf549901b60d2baaca446f46c74fJP0011000000q6PEBAA200510000000br12AAA2014-08-09 06:17:42NaN0NaN株式会社エバルス高梁支店NaNNaNNaNNaNNaNNaNNaN株式会社エバルス高梁支店NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDummy_CCHospital_jpkkNot Applicable3331cf549901b60d2baaca446f46c74f株式会社エバルス高梁支店0NaNNaNNaNNaNNaNNaNNaNNaNNot ApplicableNaNNot ApplicableNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386

Last rows

hco_keycountry_codehco_source_idmodify_idmodify_dthco_business_idinactive_flaginactive_reasonhco_namehco_typehco_type_english_namesectorphone_numberfax_numberwebsiteterritory_nameformatted_nameremarksbedsjp_hco_categoryjp_hco_idjp_hospital_typejp_account_furiganajp_hco_namejp_hco_name_kanajp_hco_shortnamejp_hco_shortname_kanajp_management_large_classjp_management_small_classjp_hco_hpgp_classjp_hco_classjp_hco_kind_codejp_hco_kindjp_psychiatric_ward_nursing_typejp_related_univ_parentjp_open_close_business_datejp_hco_rep_codejp_hco_rep_kanajp_hco_rep_kanjijp_hco_pharmacy_classhco_dcf_cdjp_duplicate_hco_codejp_permitted_bedsjp_psychiatric_ward_numberjp_psychosis_hospital_bed_numberrecord_type_namehco_external_idparent_hco_keyparent_hco_namedeleted_flagaddress_line_1address_line_2suburb_towncitystatepostcodebrickmaphco_address_source_idappt_required_flagaddress_external_idaddress_phoneaddress_faxprimary_flagjp_prefecture_codejp_local_area_codejp_city_codejp_redai_prefecture_codejp_larger_section_codejp_smaller_section_codejp_address_furiganainserted_dateupdated_date
571979f4e5f71d2185e6bad9727300e38c082eJP0011000000UfpiDAAR00510000000br12AAA2021-01-30 16:34:5672005910NaN阪本病院 医療アルトマーク施設NaNNaN0879-25-1121NaNNaNNaN阪本病院 医療NaN52アルトマーク施設7200591GPサカモトビヨウイン イリヨウ医療法人社団聖心会阪本病院イリヨウホウジンシヤダンセイシンカイサカモトビヨウイン阪本病院 医療サカモトビヨウイン イリヨウその他医療GP病院(大学HP以外)1一般NaNNaNNaN246843オガワ トモヤ小川 智也病院7200591NaN52NaNNaNHospitalH7200591f4e5f71d2185e6bad9727300e38c082e阪本病院 医療0香川県東かがわ市川東NaNNaN東かがわ市香川県769-2602NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=香川県東かがわ市川東+東かがわ市" target="_blank">map</a>a0110000009osXBAAY0.0H72005910879-25-1121NaN1.037207720700NaN008000カガワケン ヒガシカガワシ カワヒガシ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
5719808b8a0d6613a72c32f1478a861c1828adJP0011000000UgMucAAF00510000000br12AAA2021-02-16 03:56:1332716040NaNマツモトキヨシアピタ宇都宮店アルトマーク施設NaNNaN028-645-7500NaNNaNNaNマツモトキヨシアピタ宇都宮店NaNNaNアルトマーク施設3271604GPマツモトキヨシアピタウツノミヤテン㈱マツモトキヨシ東日本販売・薬マツモトキヨシアピタ宇都宮店マツモトキヨシヒガシニホンハンバイ.クスリマツモトキヨシアピタウツノミヤテンマツモトキヨシアピタ宇都宮店マツモトキヨシアピタウツノミヤテンその他会社GP店舗販売業(B)(旧薬種商販売業)NaNNaNNaNNaNNaNNaNタカノ シヨウジ高野 昌司薬局薬店3271604NaNNaNNaNNaNPharmacyH32716048b8a0d6613a72c32f1478a861c1828adマツモトキヨシアピタ宇都宮店0栃木県宇都宮市江曽島本町NaNNaN宇都宮市栃木県321-0101NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=栃木県宇都宮市江曽島本町+宇都宮市" target="_blank">map</a>a0110000009pIxuAAE0.0H3271604028-645-7500NaN1.009201320100NaN024000トチギケン ウツノミヤシ エソジマホンチヨウ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
57198150ca161647947244f3280b121c11793fJP0015F00001GWAFuQAP00510000000br12AAA2021-02-24 17:02:2437821320NaN秦野調剤薬局アルトマーク施設NaNNaN0463-84-7906NaNNaNNaN秦野調剤薬局NaNNaNアルトマーク施設3782132GPハダノチヨウザイヤツキヨク㈱慶陽秦野調剤薬局ケイヨウハダノチヨウザイヤツキヨク秦野調剤薬局ハダノチヨウザイヤツキヨクその他会社GP調剤薬局NaNNaNNaNNaNNaNNaNオオノ ミキ大野 未希薬局薬店37821323782640NaNNaNNaNDeleted_Pharmacy_jpkkH378213250ca161647947244f3280b121c11793f秦野調剤薬局0神奈川県秦野市寿町NaNNaN秦野市神奈川県257-0042NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=神奈川県秦野市寿町+秦野市" target="_blank">map</a>a015F00000tFnquQAC0.0H37821320463-84-7906NaN1.014211372800NaN011000カナガワケン ハダノシ コトブキチヨウ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
5719826aca95149f82ae883ef071bb9eb7e4f9JP0011000000UgXPhAAN00510000000br12AAA2021-03-07 18:40:5184721520NaNドラッグイレブン清水バイパス店アルトマーク施設NaNNaN096-341-6355NaNNaNNaNドラッグイレブン清水バイパス店NaNNaNアルトマーク施設8472152GPドラツグイレブンシミズバイパステンJR九州ドラッグイレブン㈱ドラッグイレブン清水バイパス店JRキユウシユウドラツグイレブンドラツグイレブンシミズバイパステンドラッグイレブン清水バイパス店ドラツグイレブンシミズバイパステンその他会社GP店舗販売業(B)(旧薬種商販売業)NaNNaNNaNNaNNaNNaNハタイ シンジ畑井 慎司薬局薬店8472152NaNNaNNaNNaNPharmacyH84721526aca95149f82ae883ef071bb9eb7e4f9ドラッグイレブン清水バイパス店0熊本県熊本市北区高平NaNNaN熊本市北区熊本県860-0085NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=熊本県熊本市北区高平+熊本市北区" target="_blank">map</a>a0110000009pRxkAAE0.0H8472152096-341-6355NaN1.043105840160NaN073003クマモトケン クマモトシ キタク タカヒラ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
571983561219c4dd6e504e5ccb58daaf0bbeffJP0015F00001GW4O4QAL00510000000br12AAA2021-03-14 16:31:5934796400NaNドラッグセイムス新座中央通り店アルトマーク施設NaNNaN048-480-2100NaNNaNNaNドラッグセイムス新座中央通り店NaNNaNアルトマーク施設3479640GPドラツグセイムスニイザチユウオウドオリテン㈱富士薬品ドラッグセイムス新座中央通り店フジヤクヒンドラツグセイムスニイザチユウオウドオリテンドラッグセイムス新座中央通り店ドラツグセイムスニイザチユウオウドオリテンその他会社GP店舗販売業(B)(旧薬種商販売業)NaNNaNNaNNaNNaNNaNタカヤナギ マサユキ高柳 昌幸薬局薬店3479640NaNNaNNaNNaNPharmacyH3479640561219c4dd6e504e5ccb58daaf0bbeffドラッグセイムス新座中央通り店0埼玉県新座市東NaNNaN新座市埼玉県352-0002NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=埼玉県新座市東+新座市" target="_blank">map</a>a015F00000tFB9mQAG0.0H3479640048-480-2100NaN1.011230343000NaN021001サイタマケン ニイザシ ヒガシ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
571984b1620705937d0b98b5c6b5c3c1df831fJP0011000000Uh60PAAR00510000000br12AAA2021-02-16 03:57:3137793260NaNそうごう薬局今宿店アルトマーク施設NaNNaN045-951-1481NaNNaNNaNそうごう薬局今宿店NaNNaNアルトマーク施設3779326GPソウゴウヤツキヨクイマジユクテン総合メディカル㈱そうごう薬局今宿店ソウゴウメデイカルソウゴウヤツキヨクイマジユクテンそうごう薬局今宿店ソウゴウヤツキヨクイマジユクテンその他会社GP調剤薬局NaNNaNNaNNaNNaNNaNサカモト ケンジ坂本 賢治薬局薬店3779326NaNNaNNaNNaNPharmacyH3779326b1620705937d0b98b5c6b5c3c1df831fそうごう薬局今宿店0神奈川県横浜市旭区今宿西町NaNNaN横浜市旭区神奈川県241-0031NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=神奈川県横浜市旭区今宿西町+横浜市旭区" target="_blank">map</a>a0110000009pu0xAAA0.0H3779326045-951-1481NaN1.014112371100NaN003000カナガワケン ヨコハマシ アサヒク イマジユクニシチヨウ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
571985455f8386f730a8e3955ccfa53ca99bb3JP0015F00001PAqEgQAL00510000000br12AAA2021-02-20 20:36:3537826550NaNウェルパーク川崎中野島5丁目店アルトマーク施設NaNNaN044-322-0113NaNNaNNaNウェルパーク川崎中野島5丁目店NaNNaNアルトマーク施設3782655GPウエルパ-クカワサキナカノシマゴチヨウメテン㈱ウェルパーク川崎中野島5丁目店ウエルパ-クカワサキナカノシマゴチヨウメテンウェルパーク川崎中野島5丁目店ウエルパ-クカワサキナカノシマゴチヨウメテンその他会社GP店舗販売業(B)(旧薬種商販売業)NaNNaNNaNNaNNaNNaNシマモト カズヒコ島本 和彦薬局薬店3782655NaNNaNNaNNaNPharmacyH3782655455f8386f730a8e3955ccfa53ca99bb3ウェルパーク川崎中野島5丁目店0神奈川県川崎市多摩区中野島NaNNaN川崎市多摩区神奈川県214-0012NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=神奈川県川崎市多摩区中野島+川崎市多摩区" target="_blank">map</a>a015F000015jiAhQAI0.0H3782655044-322-0113NaN1.014135375300NaN025005カナガワケン カワサキシ タマク ナカノシマ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
571986f9af984abd3ee2e03d941b674e29bd31JP0015F00001NyMvEQAV00510000000br12AAA2021-03-20 16:38:0711799620NaNツルハドラッグ様似店アルトマーク施設NaNNaN0146-39-2680NaNNaNNaNツルハドラッグ様似店NaNNaNアルトマーク施設1179962GPツルハドラツグサマニテン㈱ツルハツルハドラッグ様似店ツルハツルハドラツグサマニテンツルハドラッグ様似店ツルハドラツグサマニテンその他会社GP店舗販売業(B)(旧薬種商販売業)NaNNaNNaNNaNNaNNaNヤハタ マサヒロ八幡 政浩薬局薬店1179962NaNNaNNaNNaNPharmacyH1179962f9af984abd3ee2e03d941b674e29bd31ツルハドラッグ様似店0北海道様似郡様似町大通NaNNaN様似郡北海道058-0014NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=北海道様似郡様似町大通+様似郡" target="_blank">map</a>a015F000013wXqWQAU0.0H11799620146-39-2680NaN1.001608117912NaN005001ホツカイドウ サマニグン サマニチヨウ オオドオリ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
571987f4ace385acaec74aeb9f90eff0dd9127JP0015F00001J7H4vQAF00510000000br12AAA2021-03-20 16:38:3455789930NaNスギ薬局宝塚小林店アルトマーク施設NaNNaN0797-61-8891NaNNaNNaNスギ薬局宝塚小林店NaNNaNアルトマーク施設5578993GPスギヤツキヨクタカラヅカオバヤシテン㈱スギ薬局宝塚小林店スギヤツキヨクタカラヅカオバヤシテンスギ薬局宝塚小林店スギヤツキヨクタカラヅカオバヤシテンその他会社GP調剤薬局NaNNaNNaNNaNNaNNaNスギウラ カツノリ杉浦 克典薬局薬店5578993NaNNaNNaNNaNPharmacyH5578993f4ace385acaec74aeb9f90eff0dd9127スギ薬局宝塚小林店0兵庫県宝塚市小林NaNNaN宝塚市兵庫県665-0034NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=兵庫県宝塚市小林+宝塚市" target="_blank">map</a>a015F00000yACouQAG0.0H55789930797-61-8891NaN1.028214552400NaN017003ヒヨウゴケン タカラヅカシ オバヤシ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386
5719881912489b6077f79f201a7ef6d56ab540JP0015F000016qduVQAQ00510000000br12AAA2021-03-20 16:36:5247734920NaNスギドラッグ可児広見店アルトマーク施設NaNNaN0574-48-8302NaNNaNNaNスギドラッグ可児広見店NaNNaNアルトマーク施設4773492GPスギドラツグカニヒロミテン㈱スギ薬局スギドラッグ可児広見店スギヤツキヨクスギドラツグカニヒロミテンスギドラッグ可児広見店スギドラツグカニヒロミテンその他会社GP店舗販売業(B)(旧薬種商販売業)NaNNaNNaNNaNNaNNaNスギウラ カツノリ杉浦 克典薬局薬店4773492NaNNaNNaNNaNPharmacyH47734921912489b6077f79f201a7ef6d56ab540スギドラッグ可児広見店0岐阜県可児市広見NaNNaN可児市岐阜県509-0214NaN<a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;q=岐阜県可児市広見+可児市" target="_blank">map</a>a015F00000iQAW9QAO0.0H47734920574-48-8302NaN1.021214471400NaN030000ギフケン カニシ ヒロミ2021-03-22 16:48:51.9403862021-03-22 16:48:51.940386